速報APP / 圖書與參考資源 / Learn SQL-tutorial|Advanced|Interview|Qu

Learn SQL-tutorial|Advanced|Interview|Qu

價格:免費

更新日期:2016-10-14

檔案大小:23.8 MB

目前版本:10.1.120

版本需求:需要 iOS 8.0 或以上版本。與 iPhone、iPad 及 iPod touch 相容。

支援語言:英語

Learn SQL-tutorial|Advanced|Interview|Quiz|Manual(圖1)-速報App

SQL is a database computer language designed for the retrieval and management of data in relational database. SQL stands for Structured Query Language.

This tutorial will give you quick start with SQL.

include:SQL Tutorial、Advanced SQL、SQL Interview Questions、SQL Online Quiz、Useful Functions

1.SQL - Overview

2.SQL - RDBMS Concepts

3.SQL - RDBMS Databases

4.SQL - Syntax

5.SQL - Data Types

6.SQL - Operators

7.SQL - Expressions

8.SQL - CREATE Database

9.SQL - DROP or DELETE Database

10.SQL - SELECT Database, USE Statement

11.SQL - CREATE Table

12.SQL - DROP or DELETE Table

13.SQL - INSERT Query

14.SQL - SELECT Query

15.SQL - WHERE Clause

Learn SQL-tutorial|Advanced|Interview|Quiz|Manual(圖2)-速報App

16.SQL - AND and OR Conjunctive Operators

17.SQL - UPDATE Query

18.SQL - DELETE Query

19.SQL - LIKE Clause

20.SQL - TOP, LIMIT or ROWNUM Clause

21.SQL - ORDER BY Clause

22.SQL - Group By

23.SQL - Distinct Keyword

24.SQL - SORTING Results

*****Advanced SQL

25.SQL - Constraints

26.SQL - Using Joins

27.SQL - UNIONS CLAUSE

28.SQL - NULL Values

29.SQL - Alias Syntax

30.SQL - Indexes

31.SQL - ALTER TABLE Command

32.SQL - TRUNCATE TABLE Command

Learn SQL-tutorial|Advanced|Interview|Quiz|Manual(圖3)-速報App

33.SQL - Using Views

34.SQL - Having Clause

35.SQL - Transactions

36.SQL - Wildcard Operators

37.SQL - Date Functions

38.SQL - Temporary Tables

39.SQL - Clone Tables

40.SQL - Sub Queries

41.SQL - Using Sequences

42.SQL - Handling Duplicates

43.SQL - Injection

44.SQL COUNT Function

45.SQL MAX Function

46.SQL MIN Function

47.SQL AVG Function

48.SQL SUM Function

49.SQL SQRT Functions

50.SQL RAND Function

Learn SQL-tutorial|Advanced|Interview|Quiz|Manual(圖4)-速報App

51.SQL CONCAT Function

52.SQL Numeric Functions

53.SQL String Functions

Learn SQL-tutorial|Advanced|Interview|Quiz|Manual(圖5)-速報App

支援平台:iPhone, iPad